Posts by Lucas Ferreira • 33 points
3 posts
-
1
votes1
answer21
viewsQ: How to select records that have no relationship between 3 tables
Assuming I have 3 tables: Company, Users and Users (which relates the other two tables) Enterprise +----+----------+--+ | ID | NOME | | +----+----------+--+ | 1 | Empresa1 | | | 2 | Empresa2 | | | 3…
sqlasked Lucas Ferreira 33 -
0
votes1
answer43
viewsQ: Is it possible to use the return of a query with GROUP_CONCAT in the WHERE clause?
I need to make a query that looks for the type of visibility that the user has, and then search for all the other users that he "sees". The user can see all the users of the company, himself and one…
-
1
votes0
answers48
viewsQ: How to handle the return of a query in the PHP database
I’m having a hard time creating the logic for handling/processing the data I receive from an SQL query in the database. My query is returning an array in the following format: My array: array = {0:…