QuerySingle to retrieve one row from 2 joined tables

Question

User-1753299103 posted

Can I use t1.* and t2.* in the following query:

var  rsRow= db.QuerySingle("select t1.*, t2.* from signin t1 INNER JOIN profile t2 ON t1.idreg = t2.idregprof where t1.idreg=@0", myid);

Thanks

Answer 1

User1724605321 posted

Hi engcanada,

Can I use "where" in th efollowing quer:

I notice you have include the "where " condition in your query and it should work , do you get any error message ?

Best Regards,

Nan Yu

Answer 2

User379720387 posted

t1.* and t2.* works in my SQL Express db