Ask Your Question

GarethT's profile - activity

2019-06-19 20:48:57 +0200 received badge  Famous Question (source)
2018-07-14 16:20:19 +0200 received badge  Famous Question (source)
2017-12-18 11:03:33 +0200 received badge  Notable Question (source)
2017-12-11 09:03:31 +0200 received badge  Notable Question (source)
2017-11-05 17:39:42 +0200 commented answer Delete records from one table when entered in to another in base

DELETE FROM TABLEA WHERE TAG IN (SELECT TAG FROM TABLEB) Thats exactly what I was after so I've marked the question as

2017-11-05 17:19:06 +0200 marked best answer Delete records from one table when entered in to another in base

I'm pretty new to SQL in base, I've got a few queries set up now with a little help (thanks JohnSUN) which is great. I'm now exploring and have successfully used the DELETE FROM command for removing multiple entries from a table but would like to go a little further.

Rather than individually deleting rows by using.. DELETE FROM "table" WHERE "Column" = '1234' I'd rather delete entries from the first table by matching entries from a column in a second table. I've had a good go but don't yet have a good enough grasp of sql to figure it out for myself.

Hopefully thats clear and thanks in advance to anyone who can help

2017-11-05 11:52:02 +0200 commented answer Delete records from one table when entered in to another in base

Still struggling, I have next to no experience with this kind of thing so please bear with me. I have two tables that bo

2017-11-04 23:59:39 +0200 commented answer Delete records from one table when entered in to another in base

I agree its not a particularly well written question having looked back at it (probably not best off writing it whilst t

2017-11-04 23:55:34 +0200 commented question Delete records from one table when entered in to another in base

I missed that checkmark and have corrected it accordingly

2017-11-04 23:53:17 +0200 marked best answer How can a make a report or query from duplicate entries in table

Hi, I'm working on a lameness and medication record for sheep using libreoffice base.

I'd like to be able to create a query that only shows records for an animal that has had its tag number entered in to the database multiple times. I'm not that sure how to go about it however. Any help would be most appreciated.

Regards

Gareth

2017-11-04 23:53:17 +0200 received badge  Scholar (source)
2017-11-04 23:51:31 +0200 received badge  Popular Question (source)
2017-11-04 12:08:32 +0200 asked a question Delete records from one table when entered in to another in base

Delete records from one table when entered in to another in base I'm pretty new to SQL in base, I've got a few queries s

2017-10-30 16:49:07 +0200 received badge  Popular Question (source)
2017-10-29 20:55:26 +0200 answered a question How can a make a report or query from duplicate entries in table

Many thanks. Ill give this a go later on

2017-10-29 16:53:23 +0200 asked a question How can a make a report or query from duplicate entries in table

How can a make a report or query from duplicate entries in table Hi, I'm working on a lameness and medication record for