sqfEntity icon indicating copy to clipboard operation
sqfEntity copied to clipboard

Querying data from two different tables

Open SrujanMungara opened this issue 2 years ago • 1 comments

I have two tables table a and table b with same primary Key.

while writing select() query, i need to fetch data from both the tables and show all the data as a single output.

How can i do this?

SrujanMungara avatar Mar 17 '22 05:03 SrujanMungara

Why don't you try using a one-to-one relationship from table b to a if they have the same primary keys?

So, you can reach the table b fields through table a like this: tableA.tableB.field

hhtokpinar avatar Mar 22 '22 21:03 hhtokpinar