皇冠hg0088代理网址

Questions tagged [join]

A JOIN is a general operation in relational algebra for a combining operation on two or more relations in a relational database system. JOIN is also keyword of the SQL language for performing this operation.

Filter by
Sorted by
Tagged with
-2
votes
1answer
23 views

How to INNER JOIN many tables? [closed]

I'm very confused to make my select. I need show the information as a table cows.ring_numbem, groups.name, rooms.name when cows.is_sold = 0 How could I do this JOINS?
0
votes
2answers
11 views

Question on left join in SAS: my code is getting wrong duplicate

below is my query and on the screenshot it's how the two datasets look like and what I want to get. **proc sql; create table new as select e.*, b.Openflag, b.OpenDate from email.sent e left join email....
0
votes
1answer
23 views

Trouble understanding inner join

Im trying to understand inner join correct use but im having trouble when I have to call more than 2 tables, im using oracle HR schema for tests, so for example im trying this query: select emps....
-2
votes
2answers
38 views

How to understand the four tables join query [duplicate]

My question is based on the answer from asemprini87 from this link:How to Join 4 tables in SQL. (please check the original tables through this link, if you are interested). My question focuses on: ...
0
votes
1answer
36 views

Can anybody please help me with my logic in SQL (no activity date last 90 days)?

I have a query  to return all the records that have no activity in the last 90 days, but it looks like it is returning records that are active in the last 90 days too. How can I fix this? my logic to ...
-1
votes
0answers
4 views

I have two string fields and want to extract a part of the strin and compare to the part of another string

Very new to this, so nothing like starting with a complicated query I have a string field in table1 - manager I have a string field in table1 - disname both strings look something like this: 'CN=Some ...
0
votes
1answer
26 views

Can I use CASE in JOIN condition

I am getting error while using CASE in JOIN statement. Below is the query. I have masked the contents. Please let me know where I am going wrong. As it looks fine to me. Pasted the error aswell. ...
0
votes
0answers
15 views

handling joins on multiple tables in hive

Below is the table structure of tables a,b,c,d and x write a query to find id, i am expecting this can be done using case statement but not sure how to put it in query. table a id name address table ...
-1
votes
0answers
12 views

ideal way to meet the scenario? [duplicate]

I have a scenario and need your valuable suggestions on the same. I am using Spring MVC with Hibernate and JPA and MySql db:- I have a website for hospital wherein in one web page I am displaying the ...
0
votes
3answers
63 views

Performance tuning complex SQL join

I'm trying to make a join on 2 tables. TableA | date | var | +------+-----+ | 1 | a | | 2 | b | | 3 | e | | 4 | c | | 5 | b | TableB | date | var | +------+-----+ | 1 | a ...
0
votes
1answer
37 views

Table Self join

Table_a has columns : old_id and new_id . Following query gives planning region and organization code for old_id. SELECT a.old_id,d.planning_region,b.organization_code FROM table_a ...
2
votes
1answer
35 views

SQL Server join tables with null value

Suppose I have these tables in SQL Server: tbl_Applicants ID | name | typeid | depid ---+------+--------+------- 1 | Mark | 1 | NULL 2 | Ted | 2 | 1 tbl_ApplicantType ID | Type ---+------...
0
votes
2answers
28 views

How to get multiple data from different relational table in mysql

I have 3 relational tables : users, posts, and reposts. In reposts table, I have fields: user_id (the user who reposted the post) and, post_id. In posts table, I have fields: id, posts, and user_id. ...
0
votes
1answer
23 views

Linux Bash Script find and join

Below are my example files. Using AccountInfo(Account) to search the sub-folder existing on FolderStatus(Sub-folder). AccountInfo #server,Account,status,homefolder vmftp01,admin01,enable,/home/admin01 ...
-1
votes
0answers
14 views

mysql - Joining 4 tables to calculate profit after deducting taxes and delivery fees

I'm currently working on this project that unfortunately did not setup their tables correctly and therefore I'm completely lost as to how to tackle the problem. I have 4 tables, orders(contains order ...

15 30 50 per page
1
2 3 4 5
2517