query for using joins and not in list

[sireesha]

Hi,



I have a list of 9 records in one table and 2 records in another table. and one more table is there. these three tables have relation.
my result of the query is 2 records showing because these 3 tables have relation.
but i want 9-2=7 other 7 records wants to display how?

Please help me asap

Regards,
Sireesha.

[June7]

Does the query use INNER JOIN? Try changing the joins to LEFT or RIGHT.

[sireesha]

Does the query use INNER JOIN? Try changing the joins to LEFT or RIGHT.

Hi,

yes, it is used inner join. but i tried for left join also but it will not work.

please review my query

FROM PurchasedVehicles, SoldVehicles, (PURCHASE INNER JOIN SALES ON PURCHASE.PURCHASE_ID = SALES.PURCHASE_ID) INNER JOIN REP ON (puRCHASE.ID = REP.ID) AND (REP.ID = SALES.ID)

i will get a result of sales table result. but i need to display remaining purchased list.

on sales before leftjoin is used. but it will get an error.

please help me asap

Regards,
Sireesha.

[June7]

If you want to provide db for analysis and testing, I will try. Follow instructions at bottom of my post.