|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
|
|
#1
|
|||
|
|||
|
JOIN tables problem
I am using mysql,
I have two mysql queries; select * from booking_repeat; select * from booking_entry where entry_type='0'; how to make this two queries into one. i need the records from this two tables to display together in one screen. thanks. |
|
#2
|
||||
|
||||
|
RE: JOIN tables problem
If you don't want any special ordering or anything try this:
select * from booking_repeat, booking_entry where entry_type='0'; If there is also an entry_type column in booking repeat then you'll have to specify : select * from booking_repeat as br, booking_entry as be where be.entry_type='0'; or select * from booking_repeat as br, booking_entry as be where be.entry_type=br.entry_type and be.entry_type='0'; Choose the one you need |
|
#3
|
|||
|
|||
|
RE: JOIN tables problem
You can read more about JOIN tables here:
http://forums.devshed.com/t67748/s96a8bf37330f5752fed37ba90899384e.html |
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > JOIN tables problem |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|