Last post Sep 06, 2017 06:53 PM by march11
Dec 03, 2012 11:27 AM|Code_warriors|LINK
Hello all. I will really appreciate some help on this querystring.
For the first page I am trying to pull all the fields in the Gold, Caret and Size tables. Please Know that there is a session variable being passed from the masterpage to the page which represents the Mineral#. (please apply all the joins.).
So to repeat we need all the feilds in Gold, Caret and Size tables, where Mineral# = Session["mSet"]
Here is the table structure
I was thinking about the traffic so I am trying to pull all the data I need in one process, but maybe I should point out that the data in the sqldatasource (the three tables) are going into three seperate listboxes.
Sep 06, 2017 06:53 PM|march11|LINK
Have you made any effort to code this query yet? How about taking a crack at it, and posting your effort and we can chime in with comments or corrections.
P.S. you will need a foreign key to JOIN to the third table.