information from 2nd table (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

iany -> information from 2nd table (1/23/2005 11:16:24)

Rewriting a results query in asp which works in FrontPage so that I can load information from different tables.
Query

"SELECT *, Table2*. FROM Table LEFT JOIN Table2 ON Table.field = Table2.fieldcode " is FrontPage query

"SELECT *FROM Table LEFT JOIN Table2 ON Table.field = Table2.fieldcode " is query I am using,

I need to be able to lift "Table2.field" in the results page rather than the numeric fieldcode.

Ian



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875