[TYPO3] SQL Query

Dmitry Dulepov typo3 at accio.lv
Wed Aug 9 09:32:26 CEST 2006


Hi!

Felipe Knaesel Koch wrote:
> Anyway of doing this: “SELECT re.uid reid, re.rid roid, ro.title room,
> re.event event, re.user user, co.date date, co.hid hour
> 
> FROM `tx_fkkcrr_reservations` AS re, `tx_fkkcrr_reservations_content` AS co,
> `tx_fkkcrr_rooms` AS ro
> 
> WHERE co.reid = re.uid
> 
> AND re.rid = ro.uid;” with $GLOBALS[‘TYPO3_DB’]? (except of course sql_query
> method).

Use full table names, not aliases. I remember doing something similar once.

-- 
Dmitry Dulepov
ACCIO Ltd, Latvia
http://accio.lv/en/

"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)



More information about the TYPO3-english mailing list