StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POsql query repeat
text
Body
copied!<p>My query is like below (not working correctly)</p> <pre><code>SELECT RentACar.dbo.Car.car_id as clm_CAR_ID, RentACar.dbo.Car_Image.car_image_url as clm_PICTURE_URL, RentACar.dbo.Users.user_agent_name as clm_USERNAME from RentACar.dbo.Car left join RentACar.dbo.Users on RentACar.dbo.Car.car_user_id = RentACar.dbo.Users.user_id left join RentACar.dbo.Car_Image on RentACar.dbo.Car.car_id = RentACar.dbo.Car_Image.car_image_car_id </code></pre> <p>my aim is that show all the cars at car_table whith user_name of user_table and picture_url of image_table.</p> <p>But at the image_table i have a problem.. a car can has more than a picture.</p> <hr> <p>this query results;</p> <pre><code>clm_CAR_ID clm_PICTURE_URL clm_USERNAME 1 NULL ac ad 2 NULL ac ad 3 NULL ac ad 4 NULL ac ad 5 /upload/10CeskUntitled23-11.png ac ad 5 /upload/10CveloperDesktopdeskUntitl4ed-11.png ac ad 6 NULL ac ad 7 NULL ac ad 8 NULL ac ad 9 /upload/9ngsdeveloperDesktopmelekkım.jpg ac ad 9 /upload/9eskt1opmelekkktc.jpg ac ad 10 /upload/10CeveloperDesktopd2eskxm.jpg ac ad 10 /upload/10ngsdeveloperDesktopdeskxm.jpg ac ad 10 /upload/10sdeveloperDesktopdeskU5ntitled-11.png ac ad </code></pre> <hr> <p>but my expaction result</p> <pre><code>clm_CAR_ID clm_PICTURE_URL clm_USERNAME 1 NULL ac ad 2 NULL ac ad 3 NULL ac ad 4 NULL ac ad 5 /upload/10CeskUntitled23-11.png ac ad 6 NULL ac ad 7 NULL ac ad 8 NULL ac ad 9 /upload/9ngsdeveloperDesktopmelekkım.jpg ac ad 10 /upload/10CeveloperDesktopd2eskxm.jpg ac ad </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload