Skip to Content
Former Member
Dec 15, 2006 at 06:42 AM

join query for three tables


Hi i have got this query that is a join of two tables but i need join for three tables i need the extended query

select aauthlname aauthlnam aauthfname aauthfnam aisbn btitle

from ( bsauthors as a inner join bsbook as b on aisbn = bisbn )

into corresponding fields of table books

where aauthlname like authorlname or aauthfname like authorfname

order by aauthlname aauthfname a~isbn.