nested sql in c#

FireGuy

New Member
I use an OLEDB connection to my database(access), and im trying to make a nested sql-statement. i don't get it to work...<BR>here is my statement:<BR><BR>"SELECT Stats.startdate, Members.title FROM Members, Stats WHERE (Members.familyname = Stats.familyname) = Session["lastname"]";<BR>.....<BR>then i use a datareader to get some info from the DB, like this:<BR>startdate = myReader["Stats.startdate"].ToString()
 
Back
Top