General information
Category:
Coding, syntax & commands
Title:
Syntax fo SELECT with several OUTER JOINs (VFP 5)?
I have a main table (schedule) with several (6) look-up tables (location, category, contact, ...).
They are related by key fields (schedule.loc_id -- location.loc_id, etc.) The schedule table does not necessarily have these fields entered (the client wants them optional).
What is the syntax for several outer joins with SELECT? I took a shot at it with the query builder, but it doesn't retrieve the right data either.
Setting relations and running reports works, but I have to export this to Excel.
Any help or alternatives are greatly appreciated.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only