Skip to main content

New answers tagged

0 votes
Accepted

SQLite Join 2 tables with table1 having two columns that reference table2

You can not join the same table twice or more, so use Aliases, so that the database understands, what you want SELECT jobs.job_name, desc1.desc_name ,desc2.desc_name FROM jobs JOIN ...
nbk's user avatar
  • 8,466
0 votes

SQLite Join 2 tables with table1 having two columns that reference table2

You reference the table description twice, so you need to assign each reference a unique alias.
mustaccio's user avatar
  • 26.3k
1 vote

import extended properties of sql server database from xls file

The TSQL script way of adding an Extended property is via sp_addextendedproperty Slightly altered example from the documentation: USE AdventureWorks2022; GO EXEC sp_addextendedproperty @name = N'...
Zikato's user avatar
  • 5,102
0 votes

SQL query to get the names of the partitions which are detached from the parent table in postgres?

Those tables are no longer attached to the partition parent, you need another way to identify them. Your comment indicates the naming pattern 'user_session_data_%'. This returns all tables matching ...
Erwin Brandstetter's user avatar
0 votes

Mongodb tree structure questions and answers

The questions should show based on what answer the user have selected and some answers may have multiple question sets below that as well (E.g.: Ans B). Can someone help me on the mongodb collection ...
prasad_'s user avatar
  • 468

Top 50 recent answers are included