I had to get the town name and state from database which deployed the first reciever(a device to sense sharks). I used the following query with a subquery computing MIN of deployed dates: SELECT t.town,t.state,r.deployed FROM receiver as r inner…
Am trying to select join record from TABLE_USER_MATCHES if the uid, is not the one that created the match m_from. My intention is to join records from TABLE_USER_MATCHES if it exist and it's not created by m_from p1 and also…
I am using PostgreSQL 9.5 I have two table: A ID | isStatusA | IsStatusB | IsStatusC 0 | true | false | true A table has only 1 row for data i need. Also i have B table with:…
I want to export some data from the DB. Basically what I want to say is this: 1- Select mbr_name from the members table 2- Choose the ones that exist at the course_registration table (based on mbr_id) 3- Join the…
I have two related tables like below : Users : public partial class Users { [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")] public Users() { } public int ID { get; set; } public int UserType_ID { get; set; } public string Email { get;…
I want all the 'acteurs' of a table in the value of a option, but I don't know how to. I have two tables, 'auteurs' and 'posts'. In the posts table I have a column named 'auteur_id' that has a…
I have to need a project school, a site like ebay with bid. I have to make a select who select the name of the seller the name of the last "customer" (bid) BUT THE PROBLEM is that there two…
"mytest_people" and "mytest_hobbies": PK FK <--- PK +----+------+------+------+ +----+-----------------+ | Id | Name | Age | H_ID | | Id | Hobby | +----+------+------+------+ +----+-----------------+ | 0 | Pete | 100 | 0 | | 0 | Reading News |…
Tables and data: CREATE TABLE major ( id INT PRIMARY KEY, name VARCHAR(200) ); insert into major values (101, 'Computing'), (102, 'Arquitecture'); CREATE TABLE student ( id INT PRIMARY KEY, name VARCHAR(200), major_id INT, foreign key(major_id) references major(id) ); insert…
I have 2 tables. The first, called stazioni, where I store live weather data from some weather station, and the second called archivio2, where are stored archived day data. The two tables have in common the ID station data (ID…