select_command = select concat(p.proj_id,'-',cabs.cab_id) as 'key',
FROM projects p
LEFT JOIN cabs ON p.proj_id = cabs.proj_id_f
Above is my sql command. I want to have a composite key with two colums from different tables. Key is empty when there is no cabs.cab_id in a line
How can I fix this or how can I have a unique key?
1 Answers
Your Answer