var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I am very new to Datbase joins. So please bear with me about this simple basic question. I have given 3 tables as below.
ID Close Price
Now I want a result set like this
ID OpenPrice ClosePrice ClientName
How can I achieve this by SQL joins? Can some one please help?
Hello John, the SQL statement is :select ID,openPrice,closePrice,ClientName from table1,table2,table3 where table1.ID=table2.ID=table3.ID
By the way, if you just want to print the result or show it on the spreadsheet, you can try esCalc. With esCalc, you can realiza your goal without writing any code.