SQL Catch 5 Records for 3 SQL Tables

Asked

Viewed 17 times

-3

Make a query in SQL with the tables cl_usuario, cl_loja and cl_cidade and return only 5 records with the names of the users, their cities, the names of the stores that are linked and date the user was registered.

cl_usuario: id_idade, id, id_cidade, cl_ativo, id_loja, cl_nome, id_permissao, cl_inicio, cl_email;

cl_loja: id, cl_nome, cl_telefone, cl_endereco, cl_ativo, cl_logintude, cl_latitude, id_gps, id_rota;

cl_city: id, cl_name , cl_active, cl_state, cl_parents, cl_zone.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.