Unanswered: Joining four tables,one of them to be left joined
I am a regular mysql/php developer.I am having problem in joining multiple tables in MS Access 2003.
The three tables are to be cross joined while the fourth is to be left joined.All The tables have a unique tabnumber to join each other with.
The query goes something like this-
SELECT a.*, b.*, c.*, d.*
FROM tabA AS a
join tabB AS b ON a.tabnum = b.tabnum
join tabC AS c on b.tabnum = c.tabnum
left join tabD as d on c.tabnum = d.tabnum
Can anybody please tell me te correct way to write this query so that MS Access can understand this it.