In Progress

FP2003 ASP Inner-Outer Join Solution

Frontpage2003, Access2003 SP3.

I'm trying to do a query that has three tables inner-joined, with the right-most table left-joined on a fourth table. The fourth table is a query result of two inner-joined tables (filtered for name=John, e.g.).

I can't figure out how to do this as a single SQL statement (so I can build it in front page), since it results in ambiguous inner and outer joins. I've tried nesting and subqueries, but can't tell if my coding is wrong, or if I just can't do it that way.

I think I can solve it by having an include that runs a "create table" function as page is opened. This would creating needed fourth table based on the variable passed in the url (e.g name=john) and then I can include the new table in the DRW SQL statement that will have the left-join I want on that page and display the fields I desire.

I do not know the sytax to add to the frontpage code window to achive either the single line SQL solution, or the create table solution.

Can you assist?

Skills: ASP, Website Design

See more: solution n, design website asp, coding window, coding design asp website, solution, single line, join, inner, drw, line asp, page inner, build front page website, design solution, joins, coding join table, query design, single page website needed, fourth, query results website, create table website, inner page website design, sql add fields table, sql code add fields, sytax, frontpage2003

About the Employer:
( 4 reviews ) stockton, United States

Project ID: #1139068

3 freelancers are bidding on average $116 for this job

shmai

have a glance at Pm. Regards,

$100 USD in 2 days
(201 Reviews)
7.1
WebCr8tor

the cost could be very low if I have the full detail. Or maybe you just can code it on ASP if you find it hard to query it on SQL..

$149 USD in 5 days
(0 Reviews)
0.0
manumonvat

dear sir I am having a strong background in software development, and engineering, and believe that these skills would benefit the designing and manufacturing aspects of Template software. My qualifications make me More

$100 USD in 5 days
(0 Reviews)
0.0