I'm not very familiar w/ Pervasive SQL syntax. The SELECT query runs on MS SQL but syntax error in Pervasive SQL.

Here's my query in MS SQL
I use LEFT OUTER JOIN because all data on CustomerTable should be displayed even if ProdID is null in value.

What's the equivalent syntax of LEFT OUTER JOIN in pervasive SQL? The query below runs on Pervasive SQL but I cannot do this query because it means INNER JOIN.

What version of PSQL are you using?
Here's a link to the v9.5 JOIN syntax:
http://www.pervasive.com/library/doc...ref-04-53.html

thanks mirtheil :-)