![]() How can I post the error messages of T-SQL results (or Microsoft. Please kindly help, advise and respond again. ![]() to use the expressin to extract the "detected" valuesĢ) What is the difference between "UNION" and "JOIN" in gerenal? I am learning the "UNION" and the "JOIN" further now. The T-SQL code!? How can I do "SELECT" for the desired columns in the result set? How can I save the desired result set as a new file for the future use in my new query (i. But it printed out all the columns of the result set - I do not want the extra repeated columns in the result set. Instead of *, if I specified some columns in dbo.Table_1_XYcoord, I got some errors that prevent me from executing Hi Naomi and Scott M., Thanks for your responses.ġ) I tried the (RIGHT) JOIN my dbo.Table_2_APG_Soil (or dbo.Table_3_APG_Water) on my dbo.Table_1_APG_XYcoord and executed the following code: SELECT * FROM dbo.Table_1_APG_XYcoord AS T1 JOIN dbo.Table_3_APG_Water AS T3 ON T1.sample_id = T3.sample_id ORDER BY T3.sample_id
0 Comments
Leave a Reply. |