This question has already been answered:

There are 4 tables:

Vigruzka User_Name0 Name0 DisplayName0 Publisher0 LastW Anna.CM Anna Skype Microsoft 2.0.9 ... rows 700 Users Id_users User_Name0 Name0 1 Anna.CM Anna ... rows 3 Programs Id_programs DisplayName0 Publisher0 1 Skype Microsoft ... rows 300 Updates Id_updates id_Users Id_programs LastW 1 1 1 2.0.9 ... rows 300

How to display (make a selection) the Updates table so that it looks like:

 Updates Id_updates id_Users Id_programs LastW 1 Anna.CM Skype 2.0.9 ... rows 300

Ie that for the place of figures there was related data.

Tables are related

Display through the command Select * from updates;

Reported as a duplicate by Mike , Denis Bubnov , rjhdby , Yuri , ߊߚߤߘ Mar 5 '17 at 8:24 .

A similar question was asked earlier and an answer has already been received. If the answers provided are not exhaustive, please ask a new question .

    1 answer 1

     SELECT upd.Id_updates, usr.User_Name0 as id_Users, prg.DisplayName0 as Id_programs, upd.LastW FROM Updates upd LEFT JOIN Users usr ON usr.Id_users = upd.id_Users LEFT JOIN Programs prg ON prg.Id_programs = upd.Id_programs
    • Thanks, what I was looking for - Fedor