Write an SQL from more than one tabels

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

Write an SQL from more than one tabels

Author

Topic

gerten
Starting Member

17 Posts

Posted - 2003-03-12 : 05:51:32

I have tree tabels in Access
Person
Viktreg
Grupp
In an ASP site i wrote an SQL wich get all data from person and gropname from grupp.
Now i'll get average ,max, min, Lost weight from Viktreg.

I started too wright an SQL but get this message.

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][Drivrutin för ODBC Microsoft Access] Syntaxfel i FROM-instruktion.
/banta/medlemssida.asp, line 36

Here are the SQL:

Sql =_
" select * from person," &_
" (Select gruppnamn from grupp inner join person on grupp.gruppid = person.gruppid)"&_
" (select Avg(Viktreg.Vikt) as MedelVikt from grupp inner join (Person inner join Viktreg"&_
" on Person.Personid = Viktreg.Personid) on grupp.Gruppid = Person.Gruppid"

Can anyone help me

Best reg

Gert

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2003-03-12 : 06:27:23

Try this:

select *,
(Select gruppnamn from grupp inner join person on grupp.gruppid = person.gruppid),
(SELECT Avg(Viktreg.vikt)FROM (Viktreg INNER JOIN Person ON Viktreg.Personid = Person.Personid) INNER JOIN grupp ON Person.gruppid = grupp.gruppid)
from person;

___________________________________________________________________________
Success is not a destination that you ever reach. Success is the quality of your journey.

gerten
Starting Member

17 Posts

Posted - 2003-03-12 : 12:45:58

Hi samsekar,

I try this and it says that it couldn't find the object or the name in line 123
Line 123 <%=rs("gruppnamn")&>

Gert

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2003-03-12 : 23:57:19

select *,
(Select gruppnamn from grupp inner join person on grupp.gruppid = person.gruppid) as gruppnamn,
(SELECT Avg(Viktreg.vikt) FROM (Viktreg INNER JOIN Person ON Viktreg.Personid = Person.Personid) INNER JOIN grupp ON Person.gruppid = grupp.gruppid) as MedelVikt
from person;

___________________________________________________________________________
Success is not a destination that you ever reach. Success is the quality of your journey.

gerten
Starting Member

17 Posts

Posted - 2003-03-13 : 16:02:33

Thanks Samsekar now i got it.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources