Hello
I have the following query in a query field
Code:
SELECT *
FROM `#__invoices_invoices` AS `i`
LEFT JOIN `#__invoices_contacts` AS `co`
ON (`co`.`id` = `i`.`user_id`)
LEFT JOIN `#__users` AS `u`
ON (`u`.`id` = `co`.`user_id`)
WHERE ( `u`.`id` = '[user_id]' )
AND `i`.`type` = '1'
ORDER BY `i`.`real_invoice_num` DESC
LIMIT 24
And I'd like to display the id as [column_id] but doing this displays the user id instead of the invoices table id.
Can you tell me what I'm doing wrong here ?
I tried to write [column_i_id] but no luck neither
Thanks
Jean
