<----- REEEEEEEEEEEALLLy new 🙂

What exactly does that mean?

Heres some sample Data:

661766 RAQA

670425 TAC

670425 RAQA

674365 RAQA

682568 RAQA

682568 TAC

682568...

Thanks for the try but that too is not working. Its giving me the same data where it will bring up a request id multiple different times as each request...

I tried that but now I am not getting any results coming back.

SELECT

a.request_id,

a.req_type,

a.status,

b.event_type,

b.person_id_from,

a.check_for_billing,

a.billing_allowed,

c.text_line_code

FROM

Request a left outer join request_event b on a.request_id = b.request_id left outer join request_text c on a.request_id...

I am testing now and tweeking just a bit but I think you've got it!! Wow I hope one day I can do somthing this complex as fast as you...

I will try that out thanks very much!

Sorry that didnt come out as nicely as I thought but the colums are the same as my SELECT statement.

So say serial number A1234 came up twice in the last 60 days I would like to output:

Request_ID SERIAL_ID PLACE_ID EVENT_DT

123456 ...

Thank you first of all for such fast response I do appreciate the help! 😀

Thinking it over I would like to see any serial numbers that have been "ordered" more...

SELECT

a.Request_ID,

c.Serial_ID,

a.Place_ID,

b.event_dt

FROM

request a JOIN request_event b

ON a.request_id = b.request_id

JOIN request_product c

ON b.request_id = c. request_id

WHERE

Here is where I get into the clueless mode!

So what I want to...

Thank you I will check out that site.

Forgive me im very brand new only been doing this for about a week. But in the future when I have a question...