Search:

Hi Martin,

Perhaps your query syntax is causing some confusion. Try this.

as select a.*,b.companyname from products a left join suppliers b on a.supplierid = b.supplierid.

Also - you need to...

Hi Martin,

You can, but you have to let Lianja know which fields you want to ignore.


For example, I created two tables.



I create my virtual table using both tables.