[RESOLVED] Missing keyword sql
Anyone? :sick:
Got it ( - - )
Code:
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
Re: [RESOLVED] Missing keyword sql
Code:
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?