Recent content by Darqor

  1. D

    SQL - join three fields - same table into one column

    The intension is the same, i just have different data to put in one column. mackyrm wanted 3 columns together ( three different phone numbers ) and i want to put together 3 columns as well with different data ( column1=first name, column2=last name, column3=number ) Present data: column names...
  2. D

    SQL - join three fields - same table into one column

    I tried this, but i get only one column... could anyone tell me why? what am i doing wrong? Thx. SELECT `firstname` FROM `clients` AS `name` UNION ALL Select `lastname` FROM `clients` UNION ALL Select `number` FROM `clients`
Back
Top Bottom