Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SELECT STATEMENT PROBLEM!

Status
Not open for further replies.
Blood22

Blood22

Technical User
Jul 14, 2003
7
GB
The table I am using is titled : Booking table.

It consists of the following fields:

bookingid
userid
planereg
starttime
endtime

I am trying to produce a SELECT statement that will
SELECT * FROM booking WHERE
planereg = "Cessna 150" AND
starttime = "10:00:00" AND

So far so good everything is fine!

I don't know how to add in * IF starttime is less than 10:00:00 AND endtime is greater than 10:00:00 with the same booking id THEN do something...

Does anyone know how to phrase this mammoth statement!!!

Pleeeese help me!

Thanks

Si22.
 
Status
Not open for further replies.

Similar threads

Arthur Lewis
  • Locked
  • Question
How to effect a NOWAIT in the LOCK TABLES statement?
Replies
0
Views
86
Arthur Lewis
Arthur Lewis
BJZeak
  • Locked
  • Question
need help with .sql insert statement
Replies
1
Views
79
spamjim
spamjim
Samus Aran
  • Locked
  • Question
Looking for specific data using SELECT
Replies
0
Views
86
Samus Aran
Samus Aran
madcelt
  • Locked
  • Question
Select query not showing error but not showing result either
Replies
2
Views
89
madcelt
madcelt
spamjim
  • Locked
  • Question
Converting JDE Julian date to Gregorian date in SELECT statement
Replies
1
Views
138
spamjim
spamjim

Part and Inventory Search

Sponsor

Back
Top