|
This smells a lot like a homework problem, but it's the end of June so there shouldn't be much homework around right now.
You'll need to join the Mark table to the Lesson table to be able to look up the [Lesson Name] in the Lesson table, to include only those results where [Lesson Name] is equal to Lesson2. I'd then use the NOT IN operator to select those students from the Student table which don't appear in that set. In my view, NOT IN is clearer than trying to use some form of outer join and select rows which have a NULL indicating no match. On the other hand, NOT IN only works when you're trying to filter on a single column, if you have a compound key you're forced to use an outer join.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
|
Mike Dimmick wrote: it's the end of June so there shouldn't be much homework around right now.
But there is always summer school.
|
|
|
|
|
Why don't you post a half-hearted attempt at an sql statement, and we will let you know how to fix it.
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
Hi
Im using VS 2005 and C# and the Enterprise Library 2.0. I want to design an application that can't be affected by the Database engine i used (SQL Server, Orcale, My Sql, Postegree) how can i acheive that since MySql and Postegree is not supported in Ado.net as
provider.
Thanks for your help
|
|
|
|
|
|
I already install the MySql Connector Net 1.0.7 but the problem is that i can't configure the MySql database through the Enterprise Library configuration, since My Sql is not listed as factory provider, i also can't use something like that:
Database db=DatabaseFactory.CreateDatabase();
the above line can work with Sql server and Orcale but how to work with MySql.
My purpose is to unify the code regardless of the database engine.
|
|
|
|
|
Ah, so you're using the Microsoft Data Access Application Block? You're quite right, it only supports SQL Server, Oracle and DB2 out of the box. You need to modify the code if you want to support MySQL and Postgres as well. The source code for Enterprise Library is supplied in the installation package, so you can inspect that.
There's a connector here[^] which may help, but note that it already says it's outdated and the original author hasn't fixed it. Still, it may give you a start.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
Hi Friends,
Whats wrong here in the query?
insert into table1 (f1,f2,f3)
select f1 from table2 where table2.f2=4 and table2.f3=121034,1,41
I am inserting 3 values in 3 fiedls
f1=f1 of table2
f2=1
f3=41
It says
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near ','.
Naveed Kamboh
-- modified at 7:55 Thursday 29th June, 2006
|
|
|
|
|
probably you should use IN operator
SELECT f1 FROM table2 WHERE table2.f2=4 AND table2.f3 in (121034,1,41)
|
|
|
|
|
insert into table1 (f1,f2,f3)
select f1 from table2 where table2.f2=4 and table2.f3=121034,1,41
hi,
Are u supplying 3 values to query?? then u might be thinking like
(select f1 from table2 where table2.f2=4 and table2.f3=121034),1,41
if this is rite then u confirm - Is that query returning only one value??
After u shud write something like this :
select f1,1,41 from table2 where table2.f2=4 and table2.f3=121034
|
|
|
|
|
Naveed Kamboh wrote: Whats wrong here friends?
Your post could use a better subject line. A better subject line would briefly describe the problem. For example: "Syntax error in SELECT statement"
|
|
|
|
|
Hi All!
I had two table in SQL Server: tblNew_Details and tblNews. They were connected over pass by two fields: New_DetailsID in tblNew_Details with New_DetailsID in tblNews.
I design a Web Form (ASP.NET)which uses a DataList control to list all contents in tblNews table.
I only display a field that have the same New_DetailsID(in tblNews). But I have a problem which display two fields with the same New_DetailsID.
Please help!
Thanks!
|
|
|
|
|
Hi ,
I have two table with one-many relationship
table1 with following fields:ID1(PK),f11,f12..
table 2 :ID1(FK),ID2(PK),f21,f22..
I want to get ONLY ONE ROW after execute SELECT statement from
table1 join table2 via ID1
Can anyone help me!
Thanks in advance
dinhzap84xd@gmail.com
zappa
-- modified at 6:49 Thursday 29th June, 2006
|
|
|
|
|
hi,
table1 with following fields:ID1(PK),f11,f12..
table 2 :ID1(FK),ID2(PK),f21,f22..
select distinct top 1 * from table1 a inner join table2 b on a.ID1=b.ID1
no condition u specified, so this is one way to get only one row
|
|
|
|
|
thanks.I'll test it.
zappa
|
|
|
|
|
I want debug stored procedure. please help me. 
hk,linn
|
|
|
|
|
Hi,
Can someone please tell me why the following SELECT statement is bring back no results:
SELECT
WineryID_PK,
WineryName,
WineryEstablishedYear,
WineryOwner,
WineryDescription,
CountryID_PK,
CountryName,
RegionID_PK,
RegionName,
WineryDateInserted,
WineryDateUpdated,
(MemberFName + ' ' + MemberLName) AS WineryUpdatedBy,
WineryStatus,
WineryHasImage
FROM
Winery
LEFT OUTER JOIN Members
ON Winery.WineryUpdatedByID_FK = Members.MemberID_PK
INNER JOIN Region
ON Winery.RegionID_FK = Region.RegionID_PK
INNER JOIN Country
ON Region.CountryID_FK = Country.CountryID_PK
WHERE
Members.MemberUsername = 'Serasmus'
AND WineryID_PK = 20;
If I remove the Members.MemberUsername = 'Serasmus' then it bring back just the winery details, otherwise nothing. Username Serasmus does exist in the members table.
Regards,
Brendan
|
|
|
|
|
U are doing a left join with the winery table on the left side..
so the query will return 'Serasmus' only if this member's id is present in
the WineryUpdatedByID_FK column of winery table..is it?
so ur statement of "Username Serasmus does exist in the members table" is not really helpful
try executing this query part by part ... u may get a solution faster..
|
|
|
|
|
DIMPLE_R wrote: U
DIMPLE_R wrote: ur
Your answer would be easier to read if you wrote properly structured sentences and didn't use "txtspk"
|
|
|
|
|
What is txtspk?? Are you talking to me or to DIMPLE_R?? I understood him 100%!!
|
|
|
|
|
|
ma se wrote: What is txtspk??
AKA SMS Speak.
ma se wrote: Are you talking to me or to DIMPLE_R??
DIMPLE_R, that is why I quoted from his message.
ma se wrote: I understood him 100%!!
Really?? I didn't. It hurt my head.
|
|
|
|
|
Ahhh.. come one, it wasn't that bad, at least he tried helping. I appreciate his reply!
|
|
|
|
|
Thanks, but I was not thinking clearly.
I changed it to the following and it works fine:
SELECT
WineryID_PK,
WineryName,
WineryEstablishedYear,
WineryOwner,
WineryDescription,
CountryID_PK,
CountryName,
RegionID_PK,
RegionName,
WineryDateInserted,
WineryDateUpdated,
(m2.MemberFName + ' ' + m2.MemberLName) AS WineryUpdatedBy,
WineryStatus,
WineryHasImage
FROM
MemberInWinery
INNER JOIN Winery
ON MemberInWinery.WineryID_FK = Winery.WineryID_PK
INNER JOIN Members AS "m1"
ON MemberInWinery.MemberID_FK = m1.MemberID_PK
LEFT OUTER JOIN Members AS "m2"
ON Winery.WineryUpdatedByID_FK = m2.MemberID_PK
INNER JOIN Region
ON Winery.RegionID_FK = Region.RegionID_PK
INNER JOIN Country
ON Region.CountryID_FK = Country.CountryID_PK
WHERE
MemberInWinery.WineryID_FK = 20
AND MemberInWinery.MemberID_FK = 12;
Thanks for your help!! 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
