[RESOLVED] Missing keyword sql

[networkmancer]

Anyone?
Got it ( - - )

Select TRANSACTION.TRANSACTION_ID,CUSTOMER.FNAME,CUSTOMER.LNAME,PET.PNAME
from CUSTOMER
FULL JOIN TRANSACTION
ON CUSTOMER.CUSTOM_ID=TRANSACTION.CUSTOM_ID
FULL JOIN PET
ON CUSTOMER.PET_ID=PET.PET_ID
order by CUSTOMER.FNAME

[m.davide]

Select T.Transaction_ID, C.Fname, C.Lname, P.Pname
From Customer C, Transaction T, Pet P
Where C.Custom_id = T.Custom_id and C.Pet_id = P.Pet_id
order by C.Fname

does this do the same?